{smcl}
{txt}{sf}{ul off}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}E:\Github\Bolivia\00_replication_files\log-files/3_Table_E1.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res}25 Jan 2022, 22:40:03
{txt}
{com}. 
. timer on 2
{txt}
{com}. 
. eststo clear
{txt}
{com}. 
. *-----------*   
. * Table E.1 *
. *-----------*
.         * Our regressions
.         * Loop over dates
.         foreach date in ulttranstrepdate_missingsatmunmedian verificadortrepdate_missingsatthend {c -(}
{txt}  2{com}.                 * Use data set with problem booths appended at the end
.                 use "data/outputs/computo_`date'.dta", clear
{txt}  3{com}.                         
.                 * Capture cutoff (shutdown) percentile          
.                 qui su pcs_nbnn if trep_date >= tc(20oct2019 19:40:57) & ///
>                         trep_date <= tc(20oct2019 19:40:58), detail
{txt}  4{com}.                 local cutoff = `r(min)' 
{txt}  5{com}.                         
.                 * Post dummies
.                 gen pcs_centered = pcs_nbnn - `cutoff'
{txt}  6{com}.                 gen post = pcs_nbnn >= `cutoff'
{txt}  7{com}.                 gen postXpcs = post*pcs_centered           
{txt}  8{com}.                 gen margin_nbnn = mshare_nbnn - cshare_nbnn // Excluding blancos y nulos
{txt}  9{com}.                 
.                 * Recinto ID
.                 egen reci_id = group(Pais Dep Prov Muni Loc Reci)
{txt} 10{com}.                 tostring reci_id, replace
{txt} 11{com}.                 codebook reci_id
{txt} 12{com}.                 replace reci_id=reci_id+"-1" if Dep=="La Paz" & Prov=="Murillo" & ///
>                         Muni=="Nuestra Señora de La Paz" & Reci=="Unidad Educativa Privada La Paz" ///
>                         & NumMesa>=22383 & NumMesa<=22386
{txt} 13{com}.                 replace reci_id=reci_id+"-2" if Dep=="La Paz" & Prov=="Murillo" & ///
>                         Muni=="Nuestra Señora de La Paz" & Reci=="Unidad Educativa Privada La Paz" ///
>                         & NumMesa>22386
{txt} 14{com}.                 codebook reci_id
{txt} 15{com}. 
.                 * Labels
.                 label var pcs_nbnn "Reporting time percentile"
{txt} 16{com}.                 label var post "Post shutdown"
{txt} 17{com}. 
.                 * Our regression
.                 eststo: reghdfe margin_nbnn post, a(reci_id) cl(reci_id)
{txt} 18{com}.                 eststo: reghdfe margin_nbnn pcs_nbnn post, a(reci_id) cl(reci_id)
{txt} 19{com}.         {c )-}
{txt}(4 missing values generated)
reci_id was {res:float} now {res:str4}

{txt}{hline}
{res}reci_id{right:group(Pais Dep Prov Muni Loc Reci)}
{txt}{hline}

{col 19}type:  string ({res}str4{txt})

{col 10}unique values:  {res}5,297{col 51}{txt}missing "":  {res}0{txt}/{res}34,555

{txt}{col 15}examples:  {res}"1830"
{col 26}"2391"
{col 26}"3913"
{col 26}"4603"
{txt}(0 real changes made)
(0 real changes made)

{txt}{hline}
{res}reci_id{right:group(Pais Dep Prov Muni Loc Reci)}
{txt}{hline}

{col 19}type:  string ({res}str4{txt})

{col 10}unique values:  {res}5,297{col 51}{txt}missing "":  {res}0{txt}/{res}34,555

{txt}{col 15}examples:  {res}"1830"
{col 26}"2391"
{col 26}"3913"
{col 26}"4603"
{txt}(dropped 1605 {browse "http://scorreia.com/research/singletons.pdf":singleton observations})
{res}{txt}({browse "http://scorreia.com/research/hdfe.pdf":MWFE estimator} converged in 1 iterations)
{res}
{txt}HDFE Linear regression{col 51}Number of obs{col 67}= {res}    32,946
{txt}Absorbing 1 HDFE group{col 51}F({res}   1{txt},{res}   3691{txt}){col 67}= {res}      5.98
{txt}Statistics robust to heteroskedasticity{col 51}Prob > F{col 67}= {res}    0.0145
{txt}{col 51}R-squared{col 67}= {res}    0.9553
{txt}{col 51}Adj R-squared{col 67}= {res}    0.9497
{txt}{col 51}Within R-sq.{col 67}= {res}    0.0002
{txt}{col 1}Number of clusters ({res}reci_id{txt}) {col 30}= {res}     3,692{txt}{col 51}Root MSE{col 67}= {res}    0.1009

{txt}{ralign 78:(Std. Err. adjusted for {res:3,692} clusters in reci_id)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1} margin_nbnn{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 8}post {c |}{col 14}{res}{space 2} .0052324{col 26}{space 2} .0021404{col 37}{space 1}    2.44{col 46}{space 3}0.015{col 54}{space 4} .0010359{col 67}{space 3}  .009429
{txt}{space 7}_cons {c |}{col 14}{res}{space 2} .1054922{col 26}{space 2} .0002119{col 37}{space 1}  497.94{col 46}{space 3}0.000{col 54}{space 4} .1050769{col 67}{space 3} .1059076
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Absorbed degrees of freedom:
{res}{col 1}{text}{hline 13}{c TT}{hline 12}{hline 12}{hline 14}{hline 1}{c TRC}
{col 1}{text} Absorbed FE{col 14}{c |} Categories{col 27} - Redundant{col 39}  = Num. Coefs{col 54}{c |}
{res}{col 1}{text}{hline 13}{c +}{hline 12}{hline 12}{hline 14}{hline 1}{c RT}
{col 1}{text}     reci_id{col 14}{c |}{space 1}     3692{col 27}{space 1}     3692{col 39}{result}{space 1}        0{col 53}{text}*{col 54}{c |}
{res}{col 1}{text}{hline 13}{c BT}{hline 12}{hline 12}{hline 14}{hline 1}{c BRC}
* = FE nested within cluster; treated as redundant for DoF computation
{res}{txt}({res}est1{txt} stored)
{res}{txt}(dropped 1605 {browse "http://scorreia.com/research/singletons.pdf":singleton observations})
{res}{txt}({browse "http://scorreia.com/research/hdfe.pdf":MWFE estimator} converged in 1 iterations)
{res}
{txt}HDFE Linear regression{col 51}Number of obs{col 67}= {res}    32,946
{txt}Absorbing 1 HDFE group{col 51}F({res}   2{txt},{res}   3691{txt}){col 67}= {res}     15.79
{txt}Statistics robust to heteroskedasticity{col 51}Prob > F{col 67}= {res}    0.0000
{txt}{col 51}R-squared{col 67}= {res}    0.9554
{txt}{col 51}Adj R-squared{col 67}= {res}    0.9497
{txt}{col 51}Within R-sq.{col 67}= {res}    0.0013
{txt}{col 1}Number of clusters ({res}reci_id{txt}) {col 30}= {res}     3,692{txt}{col 51}Root MSE{col 67}= {res}    0.1009

{txt}{ralign 78:(Std. Err. adjusted for {res:3,692} clusters in reci_id)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1} margin_nbnn{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 1}pcs_nbnn_so {c |}{col 14}{res}{space 2} .0172381{col 26}{space 2} .0033055{col 37}{space 1}    5.21{col 46}{space 3}0.000{col 54}{space 4} .0107572{col 67}{space 3} .0237189
{txt}{space 8}post {c |}{col 14}{res}{space 2}-.0007115{col 26}{space 2} .0023447{col 37}{space 1}   -0.30{col 46}{space 3}0.762{col 54}{space 4}-.0053086{col 67}{space 3} .0038856
{txt}{space 7}_cons {c |}{col 14}{res}{space 2} .0976327{col 26}{space 2} .0015364{col 37}{space 1}   63.55{col 46}{space 3}0.000{col 54}{space 4} .0946205{col 67}{space 3}  .100645
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Absorbed degrees of freedom:
{res}{col 1}{text}{hline 13}{c TT}{hline 12}{hline 12}{hline 14}{hline 1}{c TRC}
{col 1}{text} Absorbed FE{col 14}{c |} Categories{col 27} - Redundant{col 39}  = Num. Coefs{col 54}{c |}
{res}{col 1}{text}{hline 13}{c +}{hline 12}{hline 12}{hline 14}{hline 1}{c RT}
{col 1}{text}     reci_id{col 14}{c |}{space 1}     3692{col 27}{space 1}     3692{col 39}{result}{space 1}        0{col 53}{text}*{col 54}{c |}
{res}{col 1}{text}{hline 13}{c BT}{hline 12}{hline 12}{hline 14}{hline 1}{c BRC}
* = FE nested within cluster; treated as redundant for DoF computation
{res}{txt}({res}est2{txt} stored)
(4 missing values generated)
reci_id was {res:float} now {res:str4}

{txt}{hline}
{res}reci_id{right:group(Pais Dep Prov Muni Loc Reci)}
{txt}{hline}

{col 19}type:  string ({res}str4{txt})

{col 10}unique values:  {res}5,297{col 51}{txt}missing "":  {res}0{txt}/{res}34,555

{txt}{col 15}examples:  {res}"1830"
{col 26}"2391"
{col 26}"3913"
{col 26}"4603"
{txt}(0 real changes made)
(0 real changes made)

{txt}{hline}
{res}reci_id{right:group(Pais Dep Prov Muni Loc Reci)}
{txt}{hline}

{col 19}type:  string ({res}str4{txt})

{col 10}unique values:  {res}5,297{col 51}{txt}missing "":  {res}0{txt}/{res}34,555

{txt}{col 15}examples:  {res}"1830"
{col 26}"2391"
{col 26}"3913"
{col 26}"4603"
{txt}(dropped 1605 {browse "http://scorreia.com/research/singletons.pdf":singleton observations})
{res}{txt}({browse "http://scorreia.com/research/hdfe.pdf":MWFE estimator} converged in 1 iterations)
{res}
{txt}HDFE Linear regression{col 51}Number of obs{col 67}= {res}    32,946
{txt}Absorbing 1 HDFE group{col 51}F({res}   1{txt},{res}   3691{txt}){col 67}= {res}      8.73
{txt}Statistics robust to heteroskedasticity{col 51}Prob > F{col 67}= {res}    0.0031
{txt}{col 51}R-squared{col 67}= {res}    0.9553
{txt}{col 51}Adj R-squared{col 67}= {res}    0.9497
{txt}{col 51}Within R-sq.{col 67}= {res}    0.0003
{txt}{col 1}Number of clusters ({res}reci_id{txt}) {col 30}= {res}     3,692{txt}{col 51}Root MSE{col 67}= {res}    0.1009

{txt}{ralign 78:(Std. Err. adjusted for {res:3,692} clusters in reci_id)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1} margin_nbnn{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 8}post {c |}{col 14}{res}{space 2} .0056552{col 26}{space 2} .0019138{col 37}{space 1}    2.95{col 46}{space 3}0.003{col 54}{space 4}  .001903{col 67}{space 3} .0094075
{txt}{space 7}_cons {c |}{col 14}{res}{space 2}   .10519{col 26}{space 2} .0002776{col 37}{space 1}  378.99{col 46}{space 3}0.000{col 54}{space 4} .1046458{col 67}{space 3} .1057342
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Absorbed degrees of freedom:
{res}{col 1}{text}{hline 13}{c TT}{hline 12}{hline 12}{hline 14}{hline 1}{c TRC}
{col 1}{text} Absorbed FE{col 14}{c |} Categories{col 27} - Redundant{col 39}  = Num. Coefs{col 54}{c |}
{res}{col 1}{text}{hline 13}{c +}{hline 12}{hline 12}{hline 14}{hline 1}{c RT}
{col 1}{text}     reci_id{col 14}{c |}{space 1}     3692{col 27}{space 1}     3692{col 39}{result}{space 1}        0{col 53}{text}*{col 54}{c |}
{res}{col 1}{text}{hline 13}{c BT}{hline 12}{hline 12}{hline 14}{hline 1}{c BRC}
* = FE nested within cluster; treated as redundant for DoF computation
{res}{txt}({res}est3{txt} stored)
{res}{txt}(dropped 1605 {browse "http://scorreia.com/research/singletons.pdf":singleton observations})
{res}{txt}({browse "http://scorreia.com/research/hdfe.pdf":MWFE estimator} converged in 1 iterations)
{res}
{txt}HDFE Linear regression{col 51}Number of obs{col 67}= {res}    32,946
{txt}Absorbing 1 HDFE group{col 51}F({res}   2{txt},{res}   3691{txt}){col 67}= {res}     11.61
{txt}Statistics robust to heteroskedasticity{col 51}Prob > F{col 67}= {res}    0.0000
{txt}{col 51}R-squared{col 67}= {res}    0.9553
{txt}{col 51}Adj R-squared{col 67}= {res}    0.9497
{txt}{col 51}Within R-sq.{col 67}= {res}    0.0009
{txt}{col 1}Number of clusters ({res}reci_id{txt}) {col 30}= {res}     3,692{txt}{col 51}Root MSE{col 67}= {res}    0.1009

{txt}{ralign 78:(Std. Err. adjusted for {res:3,692} clusters in reci_id)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1} margin_nbnn{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 1}pcs_nbnn_so {c |}{col 14}{res}{space 2} .0128903{col 26}{space 2} .0032836{col 37}{space 1}    3.93{col 46}{space 3}0.000{col 54}{space 4} .0064526{col 67}{space 3} .0193281
{txt}{space 8}post {c |}{col 14}{res}{space 2} .0002837{col 26}{space 2} .0023035{col 37}{space 1}    0.12{col 46}{space 3}0.902{col 54}{space 4}-.0042325{col 67}{space 3} .0047999
{txt}{space 7}_cons {c |}{col 14}{res}{space 2} .0996504{col 26}{space 2} .0014496{col 37}{space 1}   68.74{col 46}{space 3}0.000{col 54}{space 4} .0968083{col 67}{space 3} .1024924
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Absorbed degrees of freedom:
{res}{col 1}{text}{hline 13}{c TT}{hline 12}{hline 12}{hline 14}{hline 1}{c TRC}
{col 1}{text} Absorbed FE{col 14}{c |} Categories{col 27} - Redundant{col 39}  = Num. Coefs{col 54}{c |}
{res}{col 1}{text}{hline 13}{c +}{hline 12}{hline 12}{hline 14}{hline 1}{c RT}
{col 1}{text}     reci_id{col 14}{c |}{space 1}     3692{col 27}{space 1}     3692{col 39}{result}{space 1}        0{col 53}{text}*{col 54}{c |}
{res}{col 1}{text}{hline 13}{c BT}{hline 12}{hline 12}{hline 14}{hline 1}{c BRC}
* = FE nested within cluster; treated as redundant for DoF computation
{res}{txt}({res}est4{txt} stored)

{com}. 
.         * Adding FR data
.         * verificador date
.         use "data/outputs/computo_verificadortrepdate_missingsatthend.dta", clear
{txt}
{com}. 
.         * Capture cutoff (shutdown) percentile
.         qui su pcs_nbnn if trep_date >= tc(20oct2019 19:40:57) & ///
>                 trep_date <= tc(20oct2019 19:40:58), d
{txt}
{com}.         local cutoff = `r(min)' 
{txt}
{com}. 
.         * Recinto ID
.         egen reci_id = group(Pais Dep Prov Muni Loc Reci)
{txt}
{com}.                  /* Note, in constructing the data set we made a correction
>                         such that recinto names are unique within localities. */
. 
.         gen margin_nbnn = mshare_nbnn - cshare_nbnn // Excluding blancos y nulos
{txt}(4 missing values generated)

{com}. 
.         * Adding website time stamps
.         sort NumMesa
{txt}
{com}.         merge 1:1 NumMesa using "data/inputs/1_Bolivia_InEarly.dta"
{res}
{txt}{col 5}Result{col 38}# of obs.
{col 5}{hline 41}
{col 5}not matched{col 30}{res}               0
{txt}{col 5}matched{col 30}{res}          34,555{txt}  (_merge==3)
{col 5}{hline 41}

{com}.         drop _merge
{txt}
{com}.         sort NumMesa
{txt}
{com}. 
.         merge 1:1 NumMesa using "data/inputs/1_Bolivia_VotosValidos.dta"
{res}
{txt}{col 5}Result{col 38}# of obs.
{col 5}{hline 41}
{col 5}not matched{col 30}{res}               0
{txt}{col 5}matched{col 30}{res}          34,555{txt}  (_merge==3)
{col 5}{hline 41}

{com}. 
.         gen post = 1 - inEarly
{txt}
{com}. 
.         gen sMAS = 100 * MAS / VotosV
{txt}(26 missing values generated)

{com}.         gen sCC = 100 * CC / VotosV
{txt}(26 missing values generated)

{com}.         gen margin = (sMAS - sCC) / 100
{txt}(26 missing values generated)

{com}. 
.         * Labels
.         label var pcs_nbnn "Reporting time percentile"
{txt}
{com}.         label var post "Post shutdown"
{txt}
{com}. 
.         * Escobari-Hoover regression
.         eststo: reghdfe margin post, a(reci_id) cl(reci_id)
{res}{txt}(dropped 1604 {browse "http://scorreia.com/research/singletons.pdf":singleton observations})
{res}{txt}({browse "http://scorreia.com/research/hdfe.pdf":MWFE estimator} converged in 1 iterations)
{res}
{txt}HDFE Linear regression{col 51}Number of obs{col 67}= {res}    32,925
{txt}Absorbing 1 HDFE group{col 51}F({res}   1{txt},{res}   3690{txt}){col 67}= {res}      4.29
{txt}Statistics robust to heteroskedasticity{col 51}Prob > F{col 67}= {res}    0.0384
{txt}{col 51}R-squared{col 67}= {res}    0.9552
{txt}{col 51}Adj R-squared{col 67}= {res}    0.9495
{txt}{col 51}Within R-sq.{col 67}= {res}    0.0001
{txt}{col 1}Number of clusters ({res}reci_id{txt}) {col 30}= {res}     3,691{txt}{col 51}Root MSE{col 67}= {res}    0.1010

{txt}{ralign 78:(Std. Err. adjusted for {res:3,691} clusters in reci_id)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}      margin{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 8}post {c |}{col 14}{res}{space 2} .0037689{col 26}{space 2} .0018192{col 37}{space 1}    2.07{col 46}{space 3}0.038{col 54}{space 4} .0002021{col 67}{space 3} .0073357
{txt}{space 7}_cons {c |}{col 14}{res}{space 2} .1052618{col 26}{space 2}  .000288{col 37}{space 1}  365.44{col 46}{space 3}0.000{col 54}{space 4}  .104697{col 67}{space 3} .1058265
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Absorbed degrees of freedom:
{res}{col 1}{text}{hline 13}{c TT}{hline 12}{hline 12}{hline 14}{hline 1}{c TRC}
{col 1}{text} Absorbed FE{col 14}{c |} Categories{col 27} - Redundant{col 39}  = Num. Coefs{col 54}{c |}
{res}{col 1}{text}{hline 13}{c +}{hline 12}{hline 12}{hline 14}{hline 1}{c RT}
{col 1}{text}     reci_id{col 14}{c |}{space 1}     3691{col 27}{space 1}     3691{col 39}{result}{space 1}        0{col 53}{text}*{col 54}{c |}
{res}{col 1}{text}{hline 13}{c BT}{hline 12}{hline 12}{hline 14}{hline 1}{c BRC}
* = FE nested within cluster; treated as redundant for DoF computation
{res}{txt}({res}est5{txt} stored)

{com}. 
.         * Using our margin (valid votes instead of VotosValidos)
.         eststo: reghdfe margin_nbnn post, a(reci_id) cl(reci_id)
{res}{txt}(dropped 1605 {browse "http://scorreia.com/research/singletons.pdf":singleton observations})
{res}{txt}({browse "http://scorreia.com/research/hdfe.pdf":MWFE estimator} converged in 1 iterations)
{res}
{txt}HDFE Linear regression{col 51}Number of obs{col 67}= {res}    32,946
{txt}Absorbing 1 HDFE group{col 51}F({res}   1{txt},{res}   3691{txt}){col 67}= {res}      3.97
{txt}Statistics robust to heteroskedasticity{col 51}Prob > F{col 67}= {res}    0.0465
{txt}{col 51}R-squared{col 67}= {res}    0.9553
{txt}{col 51}Adj R-squared{col 67}= {res}    0.9497
{txt}{col 51}Within R-sq.{col 67}= {res}    0.0001
{txt}{col 1}Number of clusters ({res}reci_id{txt}) {col 30}= {res}     3,692{txt}{col 51}Root MSE{col 67}= {res}    0.1009

{txt}{ralign 78:(Std. Err. adjusted for {res:3,692} clusters in reci_id)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1} margin_nbnn{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 8}post {c |}{col 14}{res}{space 2} .0036005{col 26}{space 2}  .001808{col 37}{space 1}    1.99{col 46}{space 3}0.047{col 54}{space 4} .0000557{col 67}{space 3} .0071453
{txt}{space 7}_cons {c |}{col 14}{res}{space 2} .1054388{col 26}{space 2} .0002869{col 37}{space 1}  367.51{col 46}{space 3}0.000{col 54}{space 4} .1048763{col 67}{space 3} .1060013
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Absorbed degrees of freedom:
{res}{col 1}{text}{hline 13}{c TT}{hline 12}{hline 12}{hline 14}{hline 1}{c TRC}
{col 1}{text} Absorbed FE{col 14}{c |} Categories{col 27} - Redundant{col 39}  = Num. Coefs{col 54}{c |}
{res}{col 1}{text}{hline 13}{c +}{hline 12}{hline 12}{hline 14}{hline 1}{c RT}
{col 1}{text}     reci_id{col 14}{c |}{space 1}     3692{col 27}{space 1}     3692{col 39}{result}{space 1}        0{col 53}{text}*{col 54}{c |}
{res}{col 1}{text}{hline 13}{c BT}{hline 12}{hline 12}{hline 14}{hline 1}{c BRC}
* = FE nested within cluster; treated as redundant for DoF computation
{res}{txt}({res}est6{txt} stored)

{com}. 
.         * Fragment                      
.         esttab using "outputs/generated/Table_E1.tex", ///
>                 b(a2) replace alignment(S) substitute(/_ _) ///
>                 keep(post pcs_nbnn_so) ///
>                 gaps compress se nostar ///
>                 bookt fragment label nomtitles ///
>                 nodepvars nonumbers nolines obslast ///
>                 cells(b(fmt(4)) se(fmt(a2) par))
{res}{txt}(note: file outputs/generated/Table_E1.tex not found)
(output written to {browse  `"outputs/generated/Table_E1.tex"'})

{com}. 
.         * Additional formatting
.         * Insheet results
.         insheet using "outputs/generated/Table_E1.tex", clear
{txt}(1 var, 9 obs)

{com}. 
.         * Delete first line
.         drop in 1 / 1
{txt}(1 observation deleted)

{com}. 
.         * Spacing and font size
.         replace v1 = "\addlinespace[0.5ex]" if regexm(v1, "addlinespace")
{txt}(3 real changes made)

{com}.         replace v1 = "\rowfont{c -(}\scriptsize{c )-} " + v1 if regexm(v1, "\)&") 
{txt}(2 real changes made)

{com}.         replace v1 = v1 + "[-.25em]" if regexm(v1, "\)&") == 0 & ///
>                 regexm(v1, "addlinespace") == 0
{txt}variable {bf}v1{sf} was {bf}{res}str87{sf}{txt} now {bf}{res}str95{sf}
{txt}(3 real changes made)

{com}. 
.         * Label
.         replace v1 = subinstr(v1, "Post shutdown", "Post shutdown (0/1)", .)
{txt}(1 real change made)

{com}. 
.         * Obs formatting
.         replace v1 = subinstr(v1, "32", "32,", .) if regexm(v1, "Observations")
{txt}(1 real change made)

{com}.         replace v1 = "\midrule" if regexm(v1[_n + 1], "Observations")
{txt}(1 real change made)

{com}. 
.         * Outsheet
.         outsheet using "outputs/generated/Table_E1.tex", ///
>                 nonames noquote replace
{txt}
{com}. 
. *------------------------------------------------------------------------------*
. timer off 2
{txt}
{com}. timer list 2
{res}   2:      1.10 /        1 =       1.1020
{txt}
{com}. 
. log close
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}E:\Github\Bolivia\00_replication_files\log-files/3_Table_E1.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res}25 Jan 2022, 22:40:04
{txt}{.-}
{smcl}
{txt}{sf}{ul off}